Intro to Middle Neighborhoods

Justin Elszasz, Mayor’s Office of Innovation

Sunday, February 22, 2019

Housing Market Typology

The Housing Market Typologies

Our Middle Neighborhoods

Breaking “middle” into “lower middle” (F, G, H) and “upper middle” (D, E) and including “healthy” and "distressed:

Income levels in our middle neighborhoods are well below area’s

kable(hmt@data %>% head())
GeoIDwSplt bg CSP1517rsf MSP1517eo VSP1517rsf PVlVbRAcr PctFclSale Pct10kPrmt HUpResAcre MVA17HrdCd PHHOOAC6BG PHHsbAllBG Nfcl1517 hmt.tier Year.2016 Population.2016 AfricanAmerican.2016 White.2016 Asian.2016 Two_or_More.2016 Other.2016 Hispanic.2016 Household_Size.2016 Family_Household_Less_Than_3_People.2016 Family_Household_3_or_More_People.2016 Non_Family_Household_Less_Than_2_People.2016 Non_Family_Household_2_or_More_People.2016 Population_18_and_Older_Veteran.2016 Public_Assistance.2016 Median_Household_Income.2016 Below_Poverty.2016 In_Labor_Force.2016 Unemployed.2016 Less_Than_High_School.2016 HS_Complete.2016 Some_College.2016 College_Complete.2016 Beyond_College.2016 No_vehicle_available.2016 One_vehicle_available.2016 Two_or_more_vehicles_available.2016 Median_Gross_Rent.2016 Per_Units_with_Spending_Over_30Per_Income.2016 Per_Units_with_Spending_Over_50Per_Income.2016 Percent_Owner.2016 Percent_Renter.2016 Moved_in_2015_or_later.2016 Moved_in_2010_to_2014.2016 Moved_in_2000_to_2009.2016 Moved_in_1990_to_1999.2016 Moved_in_1980_to_1989.2016 Moved_in_1979_or_earlier.2016 Under_5.2016 Age_5_17.2016 Age_18_29.2016 Age_30_45.2016 Age_45_65.2016 Age_65_and_Over.2016 Percent_Households_Limited_English_Ability.2016 Percent_Homeowner_Over_65.2016 City_AreaYear.2016 City_Year.2016 City_Population.2016 City_AfricanAmerican.2016 City_White.2016 City_Asian.2016 City_Two_or_More.2016 City_Other.2016 City_Hispanic.2016 City_Household_Size.2016 City_Family_Household_Less_Than_3_People.2016 City_Family_Household_3_or_More_People.2016 City_Non_Family_Household_Less_Than_2_People.2016 City_Non_Family_Household_2_or_More_People.2016 City_Population_18_and_Older_Veteran.2016 City_Public_Assistance.2016 City_Median_Household_Income.2016 City_Below_Poverty.2016 City_In_Labor_Force.2016 City_Unemployed.2016 City_Less_Than_High_School.2016 City_HS_Complete.2016 City_Some_College.2016 City_College_Complete.2016 City_Beyond_College.2016 City_No_vehicle_available.2016 City_One_vehicle_available.2016 City_Two_or_more_vehicles_available.2016 City_Median_Gross_Rent.2016 City_Per_Units_with_Spending_Over_30Per_Income.2016 City_Per_Units_with_Spending_Over_50Per_Income.2016 City_Percent_Owner.2016 City_Percent_Renter.2016 City_Moved_in_2015_or_later.2016 City_Moved_in_2010_to_2014.2016 City_Moved_in_2000_to_2009.2016 City_Moved_in_1990_to_1999.2016 City_Moved_in_1980_to_1989.2016 City_Moved_in_1979_or_earlier.2016 City_Under_5.2016 City_Age_5_17.2016 City_Age_18_29.2016 City_Age_30_45.2016 City_Age_45_65.2016 City_Age_65_and_Over.2016 City_Percent_Households_Limited_English_Ability.2016 City_Percent_Homeowner_Over_65.2016 Year.2011 Population.2011 AfricanAmerican.2011 White.2011 Asian.2011 Two_or_More.2011 Other.2011 Hispanic.2011 Household_Size.2011 Family_Household_Less_Than_3_People.2011 Family_Household_3_or_More_People.2011 Non_Family_Household_Less_Than_2_People.2011 Non_Family_Household_2_or_More_People.2011 Population_18_and_Older_Veteran.2011 Public_Assistance.2011 Median_Household_Income.2011 Below_Poverty.2011 In_Labor_Force.2011 Unemployed.2011 Less_Than_High_School.2011 HS_Complete.2011 Some_College.2011 College_Complete.2011 Beyond_College.2011 No_vehicle_available.2011 One_vehicle_available.2011 Two_or_more_vehicles_available.2011 Median_Gross_Rent.2011 Per_Units_with_Spending_Over_30Per_Income.2011 Per_Units_with_Spending_Over_50Per_Income.2011 Percent_Owner.2011 Percent_Renter.2011 Moved_in_2015_or_later.2011 Moved_in_2010_to_2014.2011 Moved_in_2000_to_2009.2011 Moved_in_1990_to_1999.2011 Moved_in_1980_to_1989.2011 Moved_in_1979_or_earlier.2011 Under_5.2011 Age_5_17.2011 Age_18_29.2011 Age_30_45.2011 Age_45_65.2011 Age_65_and_Over.2011 Percent_Households_Limited_English_Ability.2011 Percent_Homeowner_Over_65.2011 City_AreaYear.2011 City_Year.2011 City_Population.2011 City_AfricanAmerican.2011 City_White.2011 City_Asian.2011 City_Two_or_More.2011 City_Other.2011 City_Hispanic.2011 City_Household_Size.2011 City_Family_Household_Less_Than_3_People.2011 City_Family_Household_3_or_More_People.2011 City_Non_Family_Household_Less_Than_2_People.2011 City_Non_Family_Household_2_or_More_People.2011 City_Population_18_and_Older_Veteran.2011 City_Public_Assistance.2011 City_Median_Household_Income.2011 City_Below_Poverty.2011 City_In_Labor_Force.2011 City_Unemployed.2011 City_Less_Than_High_School.2011 City_HS_Complete.2011 City_Some_College.2011 City_College_Complete.2011 City_Beyond_College.2011 City_No_vehicle_available.2011 City_One_vehicle_available.2011 City_Two_or_more_vehicles_available.2011 City_Median_Gross_Rent.2011 City_Per_Units_with_Spending_Over_30Per_Income.2011 City_Per_Units_with_Spending_Over_50Per_Income.2011 City_Percent_Owner.2011 City_Percent_Renter.2011 City_Moved_in_2015_or_later.2011 City_Moved_in_2010_to_2014.2011 City_Moved_in_2000_to_2009.2011 City_Moved_in_1990_to_1999.2011 City_Moved_in_1980_to_1989.2011 City_Moved_in_1979_or_earlier.2011 City_Under_5.2011 City_Age_5_17.2011 City_Age_18_29.2011 City_Age_30_45.2011 City_Age_45_65.2011 City_Age_65_and_Over.2011 City_Percent_Households_Limited_English_Ability.2011 City_Percent_Homeowner_Over_65.2011
245100301002 245100301002 25 165000 0.6159223 0.0133025 0.2400000 0.0135135 19.21476 C 43.70 0.3434783 6 healthy 2016 1361 0.8001470 0.0977223 0.0345334 0.0000000 0.0675974 0.0565760 2.81 0.2173913 0.4369565 0.2586957 0.0869565 0.0187377 0.0000000 42143 0.3908891 0.6926648 0.2292225 0.1751634 0.2509804 0.2104575 0.2248366 0.1385621 0.3347826 0.4000000 0.2652174 654 0.2000000 0.1586957 0.4369565 0.5630435 0.0152174 0.4478261 0.2173913 0.2782609 0.0282609 0.0130435 0.0653931 0.1895665 0.2667157 0.1814842 0.2174871 0.0793534 0.0456522 0.1652174 Baltimore 2016 620523 0.6292563 0.3038518 0.0245067 0.022705 0.0196834 0.0475019 2.521792 0.2168262 0.2973814 0.3895431 0.0962658 0.0628654 0.0559428 49978 0.2299949 0.61718 0.1144228 0.164818 0.2957807 0.2410694 0.1569683 0.1413635 0.2921749 0.4134206 0.2944004 889.6034 0.2664021 0.1431125 0.4693386 0.5306572 0.0592418 0.3574985 0.2956597 0.1228643 0.0657902 0.0989372 0.0661249 0.144122 0.2084693 0.2046548 0.2533701 0.1232557 0.0213094 0.1367122 2011 1016 0.7992126 0.1889764 0.0118110 0 0.0000000 0.0757874 2.79 0.0704225 0.4619718 0.2647887 0.2028169 0.0342556 0.0366197 30066 0.4089522 0.7575758 0.0973913 0.4112150 0.1869159 0.1271028 0.2037383 0.0710280 0.5549296 0.3352113 0.1098592 771 NA NA 0.2366197 0.7633803 NA NA NA NA NA NA 0.0905512 0.1624016 0.3572835 0.1525591 0.1092520 0.1279528 NA NA Baltimore 2011 619809 0.6370672 0.302953 0.022636 0.0207983 0.0165519 0.0395089 2.587289 0.2237825 0.3084835 0.3841903 0.0835521 0.0801731 0.0557223 44551 0.2229124 0.6230131 0.1254826 0.2142685 0.2954557 0.2304213 0.1385361 0.1213159 0.2929103 0.4143514 0.2927384 853.0291 0 0 0.4995094 0.5004948 0 0 0 0 0 0 0.0664608 0.1534586 0.2148323 0.1979626 0.2501997 0.1170893 0 0
245100602003 245100602003 81 157500 0.5137861 0.0032358 0.0987654 0.0646067 45.30012 B 63.76 0.0557491 8 healthy 2016 701 0.3437946 0.6019971 0.0000000 0.0256776 0.0285307 0.0499287 2.44 0.2822300 0.2264808 0.3310105 0.1602787 0.0114192 0.0000000 70647 0.2952924 0.8084772 0.1611650 0.0836299 0.1637011 0.0765125 0.3736655 0.3024911 0.0000000 0.5121951 0.4878049 1363 0.2055749 0.1010453 0.6376307 0.3623693 0.0975610 0.3379791 0.5017422 0.0627178 0.0000000 0.0000000 0.0485021 0.0770328 0.3423680 0.1911555 0.2910128 0.0499287 0.0000000 0.1219512 Baltimore 2016 620523 0.6292563 0.3038518 0.0245067 0.022705 0.0196834 0.0475019 2.521792 0.2168262 0.2973814 0.3895431 0.0962658 0.0628654 0.0559428 49978 0.2299949 0.61718 0.1144228 0.164818 0.2957807 0.2410694 0.1569683 0.1413635 0.2921749 0.4134206 0.2944004 889.6034 0.2664021 0.1431125 0.4693386 0.5306572 0.0592418 0.3574985 0.2956597 0.1228643 0.0657902 0.0989372 0.0661249 0.144122 0.2084693 0.2046548 0.2533701 0.1232557 0.0213094 0.1367122 2011 1084 0.2749077 0.5110701 0.0239852 0 0.1900369 0.2758303 3.27 0.0903614 0.4548193 0.2921687 0.1626506 0.0325289 0.0240964 70357 0.2130996 0.6841553 0.1104294 0.3751651 0.1268164 0.1651255 0.2021136 0.1307794 0.3313253 0.2710843 0.3975904 1310 NA NA 0.6506024 0.3493976 NA NA NA NA NA NA 0.0516605 0.0691882 0.2398524 0.3284133 0.2822878 0.0285978 NA NA Baltimore 2011 619809 0.6370672 0.302953 0.022636 0.0207983 0.0165519 0.0395089 2.587289 0.2237825 0.3084835 0.3841903 0.0835521 0.0801731 0.0557223 44551 0.2229124 0.6230131 0.1254826 0.2142685 0.2954557 0.2304213 0.1385361 0.1213159 0.2929103 0.4143514 0.2927384 853.0291 0 0 0.4995094 0.5004948 0 0 0 0 0 0 0.0664608 0.1534586 0.2148323 0.1979626 0.2501997 0.1170893 0 0
245100802001 245100802001 29 13000 1.0752509 0.1375250 0.2068966 0.0109091 28.90704 I 59.64 0.1325301 6 distressed 2016 518 1.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 3.12 0.2228916 0.4518072 0.2891566 0.0361446 0.0825000 0.1686747 50313 0.1061776 0.7647059 0.2338462 0.1522388 0.2895522 0.4776119 0.0238806 0.0567164 0.1807229 0.2951807 0.5240964 0 0.2168675 0.1024096 0.5963855 0.4036145 0.0000000 0.1987952 0.4036145 0.1686747 0.0180723 0.2108434 0.0540541 0.1737452 0.2104247 0.2258687 0.2432432 0.0926641 0.0000000 0.1987952 Baltimore 2016 620523 0.6292563 0.3038518 0.0245067 0.022705 0.0196834 0.0475019 2.521792 0.2168262 0.2973814 0.3895431 0.0962658 0.0628654 0.0559428 49978 0.2299949 0.61718 0.1144228 0.164818 0.2957807 0.2410694 0.1569683 0.1413635 0.2921749 0.4134206 0.2944004 889.6034 0.2664021 0.1431125 0.4693386 0.5306572 0.0592418 0.3574985 0.2956597 0.1228643 0.0657902 0.0989372 0.0661249 0.144122 0.2084693 0.2046548 0.2533701 0.1232557 0.0213094 0.1367122 2011 421 1.0000000 0.0000000 0.0000000 0 0.0000000 0.0000000 3.05 0.4420290 0.3043478 0.2536232 0.0000000 0.0863874 0.1159420 26705 0.0166271 0.5368957 0.0663507 0.3223684 0.5328947 0.0789474 0.0328947 0.0328947 0.3478261 0.5507246 0.1014493 1031 NA NA 0.6449275 0.3550725 NA NA NA NA NA NA 0.0142518 0.0783848 0.2185273 0.1235154 0.2541568 0.3111639 NA NA Baltimore 2011 619809 0.6370672 0.302953 0.022636 0.0207983 0.0165519 0.0395089 2.587289 0.2237825 0.3084835 0.3841903 0.0835521 0.0801731 0.0557223 44551 0.2229124 0.6230131 0.1254826 0.2142685 0.2954557 0.2304213 0.1385361 0.1213159 0.2929103 0.4143514 0.2927384 853.0291 0 0 0.4995094 0.5004948 0 0 0 0 0 0 0.0664608 0.1534586 0.2148323 0.1979626 0.2501997 0.1170893 0 0
245100805002 245100805002 41 10000 1.6594198 0.1390118 0.0731707 0.0081967 45.53274 J 45.03 0.0463576 3 distressed 2016 413 0.8983051 0.0000000 0.1016949 0.0000000 0.0000000 0.0000000 2.74 0.2384106 0.3642384 0.3973510 0.0000000 0.0147493 0.1986755 34911 0.1259080 0.5958702 0.1287129 0.2724359 0.4455128 0.1955128 0.0865385 0.0000000 0.4701987 0.4701987 0.0596026 1148 0.3443709 0.1192053 0.4503311 0.5496689 0.1258278 0.2847682 0.4172185 0.0794702 0.0264901 0.0662252 0.0411622 0.1380145 0.1162228 0.1937046 0.3438257 0.1670702 0.1258278 0.1324503 Baltimore 2016 620523 0.6292563 0.3038518 0.0245067 0.022705 0.0196834 0.0475019 2.521792 0.2168262 0.2973814 0.3895431 0.0962658 0.0628654 0.0559428 49978 0.2299949 0.61718 0.1144228 0.164818 0.2957807 0.2410694 0.1569683 0.1413635 0.2921749 0.4134206 0.2944004 889.6034 0.2664021 0.1431125 0.4693386 0.5306572 0.0592418 0.3574985 0.2956597 0.1228643 0.0657902 0.0989372 0.0661249 0.144122 0.2084693 0.2046548 0.2533701 0.1232557 0.0213094 0.1367122 2011 567 0.9770723 0.0000000 0.0000000 0 0.0229277 0.0229277 2.21 0.2918288 0.2529183 0.4085603 0.0466926 0.0671141 0.2568093 33967 0.1657848 0.5364807 0.1040000 0.2997275 0.4632153 0.1852861 0.0463215 0.0054496 0.2840467 0.5525292 0.1634241 1321 NA NA 0.3424125 0.6575875 NA NA NA NA NA NA 0.0123457 0.1992945 0.1410935 0.1904762 0.4091711 0.0476190 NA NA Baltimore 2011 619809 0.6370672 0.302953 0.022636 0.0207983 0.0165519 0.0395089 2.587289 0.2237825 0.3084835 0.3841903 0.0835521 0.0801731 0.0557223 44551 0.2229124 0.6230131 0.1254826 0.2142685 0.2954557 0.2304213 0.1385361 0.1213159 0.2929103 0.4143514 0.2927384 853.0291 0 0 0.4995094 0.5004948 0 0 0 0 0 0 0.0664608 0.1534586 0.2148323 0.1979626 0.2501997 0.1170893 0 0
245100805003 245100805003 41 10750 1.3188520 0.1258461 0.1463415 0.0059880 34.41310 J 57.41 0.1296296 6 distressed 2016 614 1.0000000 0.0000000 0.0000000 0.0000000 0.0000000 0.0000000 3.79 0.1234568 0.5555556 0.1604938 0.1604938 0.0444444 0.1666667 25000 0.4234528 0.6206897 0.2000000 0.1341853 0.3865815 0.3961661 0.0415335 0.0415335 0.4753086 0.3456790 0.1790123 1029 0.1975309 0.1481481 0.5740741 0.4259259 0.0000000 0.3888889 0.1049383 0.1172840 0.0617284 0.3271605 0.1026059 0.3110749 0.0895765 0.1726384 0.2410423 0.0830619 0.0000000 0.1851852 Baltimore 2016 620523 0.6292563 0.3038518 0.0245067 0.022705 0.0196834 0.0475019 2.521792 0.2168262 0.2973814 0.3895431 0.0962658 0.0628654 0.0559428 49978 0.2299949 0.61718 0.1144228 0.164818 0.2957807 0.2410694 0.1569683 0.1413635 0.2921749 0.4134206 0.2944004 889.6034 0.2664021 0.1431125 0.4693386 0.5306572 0.0592418 0.3574985 0.2956597 0.1228643 0.0657902 0.0989372 0.0661249 0.144122 0.2084693 0.2046548 0.2533701 0.1232557 0.0213094 0.1367122 2011 585 0.8974359 0.1025641 0.0000000 0 0.0000000 0.0000000 3.07 0.3750000 0.4293478 0.1630435 0.0326087 0.2594059 0.0380435 34773 0.1840708 0.4507576 0.3151261 0.2055675 0.4668094 0.2034261 0.1241970 0.0000000 0.3206522 0.2554348 0.4239130 1022 NA NA 0.7717391 0.2282609 NA NA NA NA NA NA 0.0051282 0.1213675 0.1504274 0.1709402 0.3606838 0.1914530 NA NA Baltimore 2011 619809 0.6370672 0.302953 0.022636 0.0207983 0.0165519 0.0395089 2.587289 0.2237825 0.3084835 0.3841903 0.0835521 0.0801731 0.0557223 44551 0.2229124 0.6230131 0.1254826 0.2142685 0.2954557 0.2304213 0.1385361 0.1213159 0.2929103 0.4143514 0.2927384 853.0291 0 0 0.4995094 0.5004948 0 0 0 0 0 0 0.0664608 0.1534586 0.2148323 0.1979626 0.2501997 0.1170893 0 0
245100903003 245100903003 64 138500 0.3432244 0.0110072 0.1718750 0.0208877 25.15057 D 86.28 0.0000000 11 upper middle 2016 572 0.4842657 0.4335664 0.0367133 0.0209790 0.0244755 0.0279720 2.05 0.2346570 0.1985560 0.3862816 0.1805054 0.0953307 0.0000000 86397 0.0244755 0.8080614 0.0000000 0.0678295 0.0775194 0.1782946 0.2868217 0.3895349 0.1119134 0.4440433 0.4440433 1265 0.0361011 0.0000000 0.8628159 0.1371841 0.0000000 0.2274368 0.3790614 0.1588448 0.0794224 0.1552347 0.0402098 0.0489510 0.1206294 0.3723776 0.2727273 0.1451049 0.0000000 0.2057762 Baltimore 2016 620523 0.6292563 0.3038518 0.0245067 0.022705 0.0196834 0.0475019 2.521792 0.2168262 0.2973814 0.3895431 0.0962658 0.0628654 0.0559428 49978 0.2299949 0.61718 0.1144228 0.164818 0.2957807 0.2410694 0.1569683 0.1413635 0.2921749 0.4134206 0.2944004 889.6034 0.2664021 0.1431125 0.4693386 0.5306572 0.0592418 0.3574985 0.2956597 0.1228643 0.0657902 0.0989372 0.0661249 0.144122 0.2084693 0.2046548 0.2533701 0.1232557 0.0213094 0.1367122 2011 738 0.1680217 0.8319783 0.0000000 0 0.0000000 0.0000000 2.37 0.2944984 0.1877023 0.2588997 0.2588997 0.0664653 0.0420712 65195 0.2086721 0.7643505 0.0533597 0.0177620 0.1527531 0.1030195 0.1634103 0.5630551 0.0420712 0.5242718 0.4336570 1444 NA NA 0.8996764 0.1003236 NA NA NA NA NA NA 0.0501355 0.0528455 0.1626016 0.4566396 0.1788618 0.0989160 NA NA Baltimore 2011 619809 0.6370672 0.302953 0.022636 0.0207983 0.0165519 0.0395089 2.587289 0.2237825 0.3084835 0.3841903 0.0835521 0.0801731 0.0557223 44551 0.2229124 0.6230131 0.1254826 0.2142685 0.2954557 0.2304213 0.1385361 0.1213159 0.2929103 0.4143514 0.2927384 853.0291 0 0 0.4995094 0.5004948 0 0 0 0 0 0 0.0664608 0.1534586 0.2148323 0.1979626 0.2501997 0.1170893 0 0

Middle neighborhoods have more older homeowners